<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Requests;
use App\Http\Controllers\Controller;
use DB;


use App\Cate;
use App\Car_info;


class IndexController extends Controller
{

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    
    
    public function index(Request $req)
    {

        $news = DB::table('carnews')->select('img','xid','title')->orderBy('xid','asc')->take(4)->get();


        $newest = Car_info::orderBy('car_id','desc')->take('12')->get();//最新上架
        $mark_down = Car_info::where('mark_down','>','0')->take('12')->get();//降价急售
        $prepare = Car_info::orderBy('car_licheng','asc')->take('12')->get();//准新车
        $practise = Car_info::orderBy('car_price','asc')->take('12')->get();//练手车

        $brands = Cate::select('cate_name','cate_id')->where('parent_id','-1')->get();//品牌
        $suv = Car_info::take('12')->get();//suv
        $bar = DB::table('seller_infos')->count();
        $brandsRes = array();       
           foreach ($brands as $br) {               
               //$cate_name = $cateData[$br['cate_id']];  
               $cate_name = $br->cate_name;
               $cate_nameFirst = $this->firstChinese($cate_name); //取出品牌的第一个汉字的首字母          
                $brandsRes[$cate_nameFirst][] = $br;//以这个首字母作为key                         
            }
        //dd($brandsRes);exit;
        return view('home.index',['bar'=>$bar,'newest'=>$newest,'prepare'=>$prepare,'practise'=>$practise,
            'suv'=>$suv,'mark_down'=>$mark_down,'brandsRes'=>$brandsRes,'news'=>$news]);
    }

    public function firstChinese($str){  
        if(empty($str)){return '';}  
        $fchar=ord($str{0});  
        if($fchar>=ord('A')&&$fchar<=ord('z')) return strtoupper($str{0});  
        $s1=iconv('UTF-8','gb2312',$str);  
        //$s2=iconv('gb2312','UTF-8',$s1);  
        //$s=$s2==$str?$s1:$str;  
        $asc=ord($s1{0})*256+ord($s1{1})-65536;  
        if($asc>=-20319&&$asc<=-20284) return 'A';  
        if($asc>=-20283&&$asc<=-19776) return 'B';  
        if($asc>=-19775&&$asc<=-19219) return 'C';  
        if($asc>=-19218&&$asc<=-18711) return 'D';  
        if($asc>=-18710&&$asc<=-18527) return 'E';  
        if($asc>=-18526&&$asc<=-18240) return 'F';  
        if($asc>=-18239&&$asc<=-17923) return 'G';  
        if($asc>=-17922&&$asc<=-17418) return 'H';  
        if($asc>=-17417&&$asc<=-16475) return 'J';  
        if($asc>=-16474&&$asc<=-16213) return 'K';  
        if($asc>=-16212&&$asc<=-15641) return 'L';  
        if($asc>=-15640&&$asc<=-15166) return 'M';  
        if($asc>=-15165&&$asc<=-14923) return 'N';  
        if($asc>=-14922&&$asc<=-14915) return 'O';  
        if($asc>=-14914&&$asc<=-14631) return 'P';  
        if($asc>=-14630&&$asc<=-14150) return 'Q';  
        if($asc>=-14149&&$asc<=-14091) return 'R';  
        if($asc>=-14090&&$asc<=-13319) return 'S';  
        if($asc>=-13318&&$asc<=-12839) return 'T';  
        if($asc>=-12838&&$asc<=-12557) return 'W';  
        if($asc>=-12556&&$asc<=-11848) return 'X';  
        if($asc>=-11847&&$asc<=-11056) return 'Y';  
        if($asc>=-11055&&$asc<=-10247) return 'Z';  
        return null;  

    }


}


